home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
PC-SIG: Essential Home & Business
/
PC-SIG - Essential Home and Business Collection.iso
/
08
/
3
/
4
/
F.GTH
< prev
next >
Wrap
Text File
|
1987-03-05
|
11KB
|
203 lines
[F] [FILE] Command
General:
Files are always loaded from or saved to the GRAPHTIME-II default drive as
indicated at the start of the status line. (Use FD command to change.)
To load/save a file from a temporary alternate drive, include the drive
specifier in the file name. e.g. B:SALES<RTN>
File types: Time-series, Series and Other (random X-Y pairs).
Subcommands:
Append Create Edit Default Input Join Load Macro Order Rename Save
Append: [FAn] (Loads FILE or TEXTED program) (n=Data, Macro, Text)
Append new data to the end of a data file either on disk or in memory.
After last entry type: E<RTN> To draw a graph after the data has been
appended, the scales should be adjusted. Use the Memory New [MN] command
Notes: Files being appended will accept null (unknown) values
by pressing <RTN>. The last entry must have a value.
After the last entry, type: E<RTN>
The File program will position data files with >42 points so
that only the last 21 points are displayed to allow space to
append further data.
Memory 0 may contain up to 365 data values. (730 for random)
Create: [FCn] (Loads FILE program) (n=Data, Macro, Text)
File Create Data: [FCD]
(Then enter the details requested by the Create-datafile menu.)
All of the questions (except the file name) have default values shown in []
Data types permitted:
Time series: Monthly, Quarterly, Yearly
Series: Any X-series with a fixed X increment.
Other: Random X-Y pairs. May be sorted into
order (increasing X values).
X values may be random or entered auto-
matically with a fixed increment.
Before entering data you must select Zero or Calculated values to be
used for missing Y-data values. [C] is the default. To enter a missing
value, press <RTN>.
For testing new Time-series data:
If you use the filename "T", all questions are bypassed and auto-
matically given the default values. This jumps straight to data entry.
Data Entry: Each number entered must end with <RTN>. Null values (ie
Y-values not known) may be entered by pressing <RTN>. GRAPHTIME will
calculate missing values to provide the best fit, provided at least the
first and last values are entered. After the last entry, type: E<RTN>
A newly created file will be entered into both memories 0 and 1.
To create more than 63 values: enter the first page of 63 values,
return to the master menu, then FAD (File Append Data).
Memory 0 may contain up to 365 data values. (730 for random data)
Data range: Largest number: +-9999997. Smallest number: +-.001
File Create Macro: [FCM] (Loads Macro/Text EDITOR - 10 seconds to initialize)
The macro may be entered with one command per line or up to 76 commands
per line. A macro may be up to 7600 characters long.
All commands are entered as a single letter. All items
longer than one character (such as filenames and dates) must be
enclosed with semicolons. eg ;SALES; ;04/86; Spaces may be used
for clarity and will be ignored when the macro is run. Default
values are used by entering a "0" in the macro. (The 0 = <RTN>)
To include Function keys in a macro use "=" followed by the first letter
of the function required. e.g. =B (Blank)
Special commands are available for slide shows:
[Tn] This command introduces a time delay of n seconds.
(At any time during a slide show, but usually between graphs.)
[*] Break. This pauses the slide show until a key is pressed. Any
key to go forward, or - to go back two * and restart.
[Jn] Jump to any command number (n).
Commands (and letters) are numbered from 1 to 7600.
Macro example 1: FL ;SALES; GC13 This will load file
"SALES" into memory 0, and display a single column graph
with pattern 3.
example 2: FL ;COSTS; GD GLL FL ;SALES; GT MS STN
(The macro may contain spaces to separate commands)
When the macro has been created, press Fn 5 key (Exit). You will be
asked to save the current file. Press "Y" then when prompted, enter
disk drive (A to D) then the macro name in full: name.GTM
Control will return to the GRAPH program.
To run a macro, use the File Macro command [FMname].
File Create Text: [FCT] (Loads Macro/Text EDITOR - 10 seconds to initialize)
Same as FCM command except that file name must be: name.GTT (See FEM cmd.)
Edit: [FEn] Where n is Data, Macro or Text.
File Edit Data: [FED filename or mem 0] (Loads FILE program)
Enter Filename or 0 to edit data in memory 0.
Enter Calculation or Zero for missing values. (C or Z)
Use the cursor keys to move directly to any value, then enter
the new value. INS and DEL can be used. To exit type: E
The next menu allows editing of all other stored values such as titles,
data type, start date, increment, labels etc.
To access data beyond the first page of 63 values, the File program
has a page select facility.
Memory 0 may contain up to 365 data values. (If more than 200, data must
be saved to disk before returning to GRAPH.)
Examples: FED MYFILE<RTN> FED 0 (File Edit memory 0)
File Edit Macro: [FEM filename] (Loads Macro/Text EDITOR)
When the editor has loaded (about 6 seconds), press Fn 9 key (Load),
then enter the drive (A to D) followed by the full filename or press
an arrow key to display and select a file directly.
The macro is loaded from disk into memory and displayed on screen for
direct screen editing. Use the arrow keys to move the cursor
anywhere within the text area. Characters can overtyped or appended
to the end. To delete a character, place cursor on the character
and press DEL. To insert a character before cursor position,
press INS then the new character(s). INS stays in effect until INS is
pressed again.
Note that function keys 3-8 have different uses with the Editor.
When complete, press Fn 5 key (Exit). Enter "Y" to save file, then at
the prompt, enter the drive (A to D) and the full file name: name.GTM
File Edit Text: [FET]
Same as for Edit Macro files, except that the saved file name
must be: name.GTT
Default-drive: [FDx]
Enquire or set the default disk drive or subdirectory for data files.
(Usually B: for floppy disk or C: for Hard disk. Enter \ then subdirectory
name). To select a different drive and subdirectory use FD twice.
Examples: FD<RTN> will display current default. FDA will set default to A:
FDC then FD\data<RTN> will select drive C: then subdirectory \DATA\.
Input: [FIx] (Loads FILE program) (x=A, D, L, G or S)
Input external data from ASCII, dBASE II/III, LOTUS 123 and SYLK files.
ASCII file conversion: [FIA]
This is used to read any ASCII file produced by programs such as
dBASE II/III. (ASCII or SDF format). Each data item must be separated
with a comma or <CR><LF>.
dBASE file conversion: [FID]
For direct input from dBASE data files, the dBASE file must contain
only one field per record for Time and Series type data, and only two
fields per record for Other type data. (X and Y data pairs.)
Lotus 123 file conversion: [FIL] or [FI1]
Output 1 (or 2) columns of data as a LOTUS print file.
Use the FIL or FI1 command to convert print file to GRAPHTIME-II format.
Select data type: where M=Month, Q=quarter, Y=year, S=series, O=other.
Select Row or Column data in the print file.
Note: If the LOTUS print file contains two rows or two columns, you must
select "Other" data to correctly input both X and Y values.
Multiplan (SYLK) file conversion: [FIS] (Loads FILE program)
The following questions will appear in sequence:
Enter source file drive:
Enter SYLK filename:
Enter data type (M Q Y S):
Enter start date as MM/YY[1/86]: or Enter lowest value of x[1]:
Enter x increment[1]:
Enter number of data items [12]:
[R]ow or Col data?
Enter Row/Col No.[1]:
Enter start Col/Row No.[1]:
When the selected Multiplan data row or column is converted it is saved
back to the selected drive in GRAPHTIME-II format. (If on floppy, change
disks before saving, if required.) For large or complex spreadsheets it
is recommended that required row or column be saved as a separate sheet.
Join: [FJn] (Where n is a memory (0 - 5) )
Joins data from any memory to the data in memory 0. The data type,
labels, start point etc. will be that of memory 0.
Load filename: [FLx] (GRAPHTIME-II format files.)
Loads the named data file into memory 0 and memory 1, ready for
graphing, statistics etc. Example: FL TESTGR1<RTN>
Macro filename: [FMx] (x=macro filename)
This is used to load and run a previously saved Macro file.
(A Macro file consists of a series of GRAPHTIME-II commands entered
with the File Create Macro command. [FCM] )
Example: FMMAC1<RTN>
To stop a macro at any time, press Esc.
(See also special Macro commands under Macro Create notes [FCM].)
Order: [FO] (Loads FILE program)
Used to sort X-Y paired random data (Data type: "other") into ascending
order. The X values are sorted. To sort the Y values, exchange memories
first. i.e. ME05 then FO command.
Rename filename: [FR old new] (Loads FILE program)
Rename an existing disk file.
e.g. FR (pause while FILE program loads)
Enter first letter of filename extension or <RTN> to list all files on
the screen. Select file to be renamed with arrow keys, then press <RTN>
Enter new filename.ext<RTN> or:
press <RTN> to go back to * menu without changing the file name.
Save filename: [FSname]
Saves the data currently in Memory 0 onto the default disk with the
specified name. Example: FS TREND2<RTN>
The current filename of memory 0 is shown in [ ].
If <RTN> is pressed, this [ ] name is used as the filename.
To cancel a File Save command, enter: 0<RTN>. (Do not press Esc or <RTN>.)
March 05, 1987